|
KMID : 1155220200450010044
|
|
Journal of the Korean Society of Health Information and Health Statistics
2020 Volume.45 No. 1 p.44 ~ p.51
|
|
|
A Study on Database Construction for Efficient Utilization of Korean National Hospital Discharge In-depth Injury Survey Data
|
|
Kim Sung-Soo
|
|
|
Abstract
|
|
|
Objectives: The present study is focused on extracting various data such as diseases, surgical operations and treatments of the Korean National Hospital Discharge In-depth Injury Survey Data to construct an effective database that can be widely used in development of policies and research.
Methods: The database construction methodology was applied to construct an effective database using the Korean National Hospital Discharge In-depth Injury Survey Data from 2006 to 2016. And for the data integration, the items and properties of data for each year were checked. As for the software to con?struct the database, the Relational Database Management System (RDBMS) MySql was used. And through normalization, the Entity Relationship Dia?gram was designed to record the DDL and DML to conduct physical modeling.
Results: As a result of checking the collected items per year, there were no problems in constructing the database. There were total of 68 items and 2,253,001 cases of sample patients. Through the normalization process, they were divided into 3 different entities and each entity was issued a primary key consisting of the year and patient number. Finally, the integrated database construction was completed by compiling the SQL for physical modeling.
Conclusions: The integrated database model of the Korean National Hospital Discharge In-depth Injury Survey Data was produced. In the future, its usage will increase as it enables effective data extraction for various researches related to diseases, surgical operations, and treatments. Furthermore, it could also be used in constructing the web-based supplying system for the Korean National Hospital Discharge In-depth Injury Survey Data.
|
|
|
KEYWORD
|
|
|
Database construction, DBMS (Database Management System), KNHDS (Korean National Hospital Discharge In-depth Injury Survey), MySql
|
|
|
FullTexts / Linksout information
|
|
|
|
|
|
Listed journal information
|
|
|
|